DB_ORACLE
UZIVATEL_________________________
create table DP_UZIVATEL(
ID_uzivatel number not null,
Meno varchar2(50),
Heslo varchar2(42),
Rok_narodenia number(4,0),
Vek number(2,0),
Mesto varchar2(20),
Styl_uzivatel varchar2(60),
Popis varchar2(200),
Zaslat_novinku number(1,0),
Pozvat_koncert number(1,0),
Ucast_koncert varchar2(40),
Oblubena_skupina varchar2(40), 
Kontakt varchar2(30),
Clen_skupina varchar2(10),
constraint DP_UZIVATEL_PK PRIMARY KEY(ID_uzivatel));
commit;

TYP
create table DP_TYP_UZIVATEL(
ID_typ_uzivatel number not null,
Typ varchar2(20),
Nastroj varchar2(100),
constraint DP_TYP_UZIVATEL_PK PRIMARY KEY(ID_typ_uzivatel));
commit;
UDALOST (koncert, festival)
create table DP_UDALOST(
ID_udalost number not null,
Nazov varchar2(40),
Text varchar2(200),
Datum date,
Vstupne varchar2(8),
Ucastnik varchar2(200),
Vystupia varchar2(100),
Typ_udalost varchar2(10),
constraint DP_UDALOST_PK PRIMARY KEY(ID_udalost));
commit;






SKUPINA
create table DP_SKUPINA(
ID_skupina number not null,
Nazov varchar2(60),
Styl varchar2(60),
Kraj  varchar2(20),
Mesto varchar2(30),
Zalozenie number(4),
Clen varchar2(60),
Hodnotenie number(1),
Info varchar2(300),
Kontakt varchar2(50),
Pocet_navstev number(6),
Novinky varchar2(30),
Heslo varchar2(42),
Aktualizacia date,
constraint DP_SKUPINA_PK PRIMARY KEY(ID_skupina));
commit;
 
SKLADBA
create table DP_SKLADBA(
ID_skladba number not null,
ID_skupina number(4),
ID_album number(4),
Nazov varchar2(30),
Rok_vydania number(4),
Styl_skladba varchar2(20),
Text number(1),
Akord number(1),
Videoklip number(1),
Hodnotenie_skladba number(1),
constraint DP_SKLADBA_PK PRIMARY KEY(ID_skladba));
commit;


AKORD
create table DP_AKORD(
ID_akord number not null,
ID_skladba number(4),
Akordy varchar2(150),
Hodnotenie number(1),
Autor number(4),
Text long,
Pridane date,
constraint DP_AKORD_PK PRIMARY KEY(ID_akord));
commit;

BLOG
create table DP_BLOG(
ID_blog number not null,
ID_autor number(4),
Nadpis varchar2(30),
Popis varchar2(100),
Text long,
Datum date,
Hodnotenie number(1),
Typ varchar2(10),
constraint DP_BLOG_PK PRIMARY KEY(ID_blog));
commit;





TEXT
create table DP_TEXT(
ID_text number not null,
ID_skladba number(4),
ID_skupina number(4),
Text long,
Hodnotenie number(1),
Autor number(4),
constraint DP_TEXT_PK PRIMARY KEY(ID_text));
commit;
ADRESA (facebook, twitter)
create table DP_ADRESA(
ID_adresa number not null,
ID_reg number not null,
Facebook varchar2(60),
Linkedin varchar2(60),
Myspace varchar2(60),
Typ number,
constraint DP_ADRESA_PK PRIMARY KEY(ID_adresa));
commit;
create table DP_ALBUM_OBRAZOK(
ID_album_obrazok number not null,
Nazov varchar2(40),
Popis varchar2(200),
miesto varchar2(200),
Datum_vytvorenia date,
Datum_aktualizacie date,
ID_skupina number,
ID_alb number,
constraint DP_ALBUM_OBRAZOK_PK PRIMARY KEY(ID_album_obrazok));
commit;
DP novinka
create table DP_NOVINKA(
ID_novinka number not null,
ID_skupina number not null,
Nazov varchar2(40),
Text long,
Pridane date,
constraint DP_UDALOST_PK PRIMARY KEY(ID_novinka));
commit;

  CREATE TABLE DP_OBRAZOK 
   (	ID_OBRAZOK NUMBER, 
	ID_SKUPINA NUMBER, 
	ID_ALBUM_OBRAZOK NUMBER, 
	TITLE VARCHAR2(50 BYTE), 
	HODNOTENIE NUMBER, 
	PRODUCTIMAGE "ORDIMAGE", 
	THUMBNAIL "ORDIMAGE", 
	POPIS "ORDSYS"."ORDIMAGESIGNATURE" , 
	ZHODA FLOAT(126), 
	POPIS_TH "ORDSYS"."ORDIMAGESIGNATURE" , 
	ZHODA_TH FLOAT(126), 
	NAHLAD "ORDSYS"."ORDIMAGE" , 
	NAHLAD_TH "ORDSYS"."ORDIMAGESIGNATURE" , 
	VLOZENE DATE, 
	INFO LONG,
constraint DP_OBRAZOK_PK PRIMARY KEY(ID_OBRAZOK));
commit;

  CREATE TABLE DP_FOTKA 
   (	ID_FOTKA NUMBER, 
	ID_UZIVATEL NUMBER, 
	ID_ALBUM_FOTKA NUMBER, 
	TITLE VARCHAR2(50 BYTE), 
	PRODUCTIMAGE "ORDIMAGE", 
	THUMBNAIL "ORDIMAGE", 
	POPIS "ORDSYS"."ORDIMAGESIGNATURE" , 
	ZHODA FLOAT(126), 
	POPIS_TH "ORDSYS"."ORDIMAGESIGNATURE" , 
	ZHODA_TH FLOAT(126), 
	NAHLAD "ORDSYS"."ORDIMAGE" , 
	NAHLAD_TH "ORDSYS"."ORDIMAGESIGNATURE" , 
	VLOZENE DATE, 
	INFO LONG,
	constraint DP_FOTKA_PK PRIMARY KEY(ID_FOTKA));
commit;
__________________________________________________________
CREATE TABLE DP_SPRAVA 
   (	ID_SPRAVA NUMBER, 
	ID_PRIJEMCA NUMBER, 
	TYP_PRIJEMCA NUMBER,
ID_ODOSIELATEL NUMBER, 
	TYP_ODOSIELATEL NUMBER,	
NADPIS VARCHAR2(50 BYTE), 
	TEXT LONG,
DATUM DATE,
VIDENE NUMBER,
constraint DP_SPRAVA_PK PRIMARY KEY(ID_SPRAVA));
commit;
______________________________________________________________-

VYTVORENIE TRIGGEROV A SEQUENCE
CREATE SEQUENCE test_sequence
START WITH 1
INCREMENT BY 1;
CREATE OR REPLACE TRIGGER dp_blog_trigger
BEFORE INSERT
ON DP_BLOG

REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT test_sequence.nextval INTO :NEW.ID_BLOG FROM dual;
END;

_____________
create sequence udalost;

create or replace trigger udalost_plus
before insert on dp_udalost
for each row
declare
    max_id number;
    cur_seq number;
begin
    if :new.id_udalost is null then
        -- No ID passed, get one from the sequence
        select udalost.nextval into :new.id_udalost from dual;
    else
        -- ID was set via insert, so update the sequence
        select greatest(nvl(max(id_udalost),0), :new.id_udalost) into max_id from dp_udalost;
        select udalost.nextval into cur_seq from dual;
        while cur_seq < max_id
        loop
            select udalost.nextval into cur_seq from dual;
        end loop;
    end if;
end;

create or replace directory mp3 as 'c:\dev\www\dp\kapely\mp3';
